Model Table BUSINESS ACTIVITY REFERENCE
Attributes
| Attribute |
Description (where applicable) |
| Activity No | Not Needed |
| Business Activity Start Date | Not Needed |
| Count Business Activity | Number of Activitis. |
| DIM_ACTIVITY_NO | Not Needed |
| Is Activity Created from Object | Whether the Activity is created from Reference Object. |
| Is Activity Created from Object Description | Whether the Activity is created from Reference Object. |
| Is Object Created from Activity | Whether the Reference Object is created from Activity. |
| Is Object Created from Activity Description | Whether the Reference Object is created from Activity. |
| Opportunity Value Estimated | Not Needed |
| Reference ID | Reference Object connected to Activity. |
| References Type Description | Type of Reference Object connected to Activity. |
| References Type Description Description | Type of Reference Object connected to Activity. |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| BUSINESS ACTIVITY REFERENCE | FACT_BUSINESS_ACTIVITY_REFERENCE_TM | FACT_BUSINESS_ACT_REF_BI | FACT_BUSINESS_ACTIVITY_REFERENCE | Data Mart |